SET NOCOUNT ON
SET QUOTED_IDENTIFIER ON
GO

-- Categorie weergaves voor het home scherm aanmaken
INSERT tblUFGTableCategories (utc_CategoryName,utc_IsShortList,utc_DisplayInMenu,utc_Order)
VALUES ('Wedstrijden',0,'AsList',2)

INSERT tblUFGTableCategories (utc_CategoryName,utc_IsShortList,utc_DisplayInMenu,utc_Order)
VALUES ('Teamindeling',0,'AsList',2)

INSERT tblUFGTableCategories (utc_CategoryName,utc_IsShortList,utc_DisplayInMenu,utc_Order)
VALUES ('Ledenbeheer',0,'AsList',2)

INSERT tblUFGTableCategories (utc_CategoryName,utc_IsShortList,utc_DisplayInMenu,utc_Order)
VALUES ('Clubbeheer',0,'AsList',2)

INSERT tblUFGTableCategories (utc_CategoryName,utc_IsShortList,utc_DisplayInMenu,utc_Order)
VALUES ('Algemeen',0,'AsList',2)

INSERT tblUFGTableCategories (utc_CategoryName,utc_IsShortList,utc_DisplayInMenu,utc_Order)
VALUES ('Financieel',0,'AsList',2)

-- Titel categorie weergaves voor het home scherm aanmaken
INSERT tblUFGTableCategoryTitles (uct_Category,uct_Language,uct_Title)
VALUES ('Wedstrijden','Nederlands','Wedstrijden')

INSERT tblUFGTableCategoryTitles (uct_Category,uct_Language,uct_Title)
VALUES ('Teamindeling','Nederlands','Teamindeling')

INSERT tblUFGTableCategoryTitles (uct_Category,uct_Language,uct_Title)
VALUES ('Ledenbeheer','Nederlands','Ledenbeheer')

INSERT tblUFGTableCategoryTitles (uct_Category,uct_Language,uct_Title)
VALUES ('Clubbeheer','Nederlands','Clubbeheer')

INSERT tblUFGTableCategoryTitles (uct_Category,uct_Language,uct_Title)
VALUES ('Algemeen','Nederlands','Algemeen')

INSERT tblUFGTableCategoryTitles (uct_Category,uct_Language,uct_Title)
VALUES ('Financieel','Nederlands','Financieel')

-- Zet tabel in categorie
DECLARE @Table_Name sysname

-- Wedstrijden
SET @Table_Name = 'tblMatches'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Wedstrijden' WHERE utb_TableName = @Table_Name



SET @Table_Name = 'tblCards'
UPDATE tblUFGTables SET utb_DisplayInCategory = NULL WHERE utb_TableName = @Table_Name

SET @Table_Name = 'tblPools'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Wedstrijden' WHERE utb_TableName = @Table_Name

-- Teamindeling
SET @Table_Name = 'tblTeams'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Teamindeling' WHERE utb_TableName = @Table_Name

SET @Table_Name = 'tblTeamMembers'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Teamindeling' WHERE utb_TableName = @Table_Name

SET @Table_Name = 'tblClasses'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Teamindeling' WHERE utb_TableName = @Table_Name

-- Ledenbeheer
SET @Table_Name = 'tblPersons'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Ledenbeheer' WHERE utb_TableName = @Table_Name

SET @Table_Name = 'tblFamilies'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Ledenbeheer' WHERE utb_TableName = @Table_Name

-- Clubbeheer
SET @Table_Name = 'tblClubs'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Clubbeheer' WHERE utb_TableName = @Table_Name

SET @Table_Name = 'tblComplex'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Clubbeheer' WHERE utb_TableName = @Table_Name

SET @Table_Name = 'tblFields'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Clubbeheer' WHERE utb_TableName = @Table_Name

-- Algemeen
SET @Table_Name = 'tblSeasons'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Algemeen' WHERE utb_TableName = @Table_Name

SET @Table_Name = 'tblFederation'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Algemeen' WHERE utb_TableName = @Table_Name

-- Financieel
SET @Table_Name = 'tblContributionDiscounts'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Financieel' WHERE utb_TableName = @Table_Name


SET @Table_Name = 'tblContributionFees'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Financieel' WHERE utb_TableName = @Table_Name

SET @Table_Name = 'tblContributionDiscountMember'
UPDATE tblUFGTables SET utb_DisplayInCategory = 'Financieel' WHERE utb_TableName = @Table_Name


